PESetSQLQuery

Use PESetSQLQuery to change the SQL query to the query string you supply as a parameter. Use this function to update the SQL query that will be used to print the specified report, typically to add optimizations to the WHERE clause.

C Syntax
BOOL CRPE_API PESetSQLQuery (
        short printJob,
        const char FAR *queryString );
Parameters

printJob

Specifies the print job for which you want to modify the SQL query.

queryString

Specifies a pointer to the null-terminated string that you want to use to replace the existing SQL query.

Returns
Remarks
VB Syntax

VB Sample Code for modifying SQL statements

Declare Function PESetSQLQuery Lib "crpe32.dll" ( ByVal printJob As Integer, ByVal QueryString As String ) As Integer

Delphi Syntax

Delphi code for getting/setting the SQL query

function PESetSQLQuery (
    printJob: Word;
    queryString: PChar
    ): Bool stdcall;
dBASE for Windows Syntax

EXTERN CLOGICAL PESetSQLQuery (CWORD, CSTRING) CRPE.DLL



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com